﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_GROUPS_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_GROUPS_IN
	END

GO

create procedure [dbo].[PRC_TB_GROUPS_IN] 
(
    @TGDESCRIPTION Varchar(150),
    @TGIDENTIFICATION Varchar(80),
    @TGNAME Varchar(150) 
)
AS
	INSERT INTO TB_GROUPS
	(TG_NAME,TG_IDENTIFICATION,TG_DESCRIPTION)
	values
	(@TGNAME,@TGIDENTIFICATION,@TGDESCRIPTION)


GO

GRANT EXEC ON dbo.PRC_TB_GROUPS_IN TO PUBLIC

GO

